<%@page pageEncoding="utf-8" contentType="text/html; charset=utf-8" %>
<%@ include file="/home/include/init_home.jsp" %>
<%@ page import="com.joinhawaii.admin.sales.*" %>
<%
	String est_no		= StringUtil.nvl(request.getParameter("est_no"));
	//String req_id		= StringUtil.nvl(request.getParameter("req_id"));


	int air_amount			= 0;		//국제선
	double total_usd		= 0;
	double deposit_usd		= 0;
	double remain_usd		= 0;
	double deposit_currency	= 0;
	double remain_currency	= 0;


	HashMap infos = new HashMap();
	infos.put("est_no",	est_no);


	SalesDAO dao 			= new SalesDAO();
	HashList estList 		= DBManager.executeQuery("/sales.xml", "select_est_voucher", infos);	//dao.selectEstInfo(infos);				//견적서
	HashList customerList	= dao.selectCustomerList(infos);
	HashList airList		= dao.selectAirList(infos);				//국제선
	HashList flyList		= dao.selectFlyList(infos);				//주내선
	HashList hotelList		= dao.selectHotelList(infos);			//호텔
	HashList enjoyList		= dao.selectEnjoyList(infos);			//선택관광
	HashList carList		= dao.selectCarList(infos);				//렌터카
	HashList insureList		= dao.selectInsureList(infos);				//기타


	deposit_currency	= estList.getDouble("deposit_currency", 0);
	remain_currency		= estList.getDouble("remain_currency", 0);


	boolean isTransfer		= false;	//주내선 경유지 유무
	for (int i = 0; i < flyList.size(); i++) {
		if (!"".equals(flyList.get("transfer_time",i))) {
			isTransfer = true;
			break;
		}
	}

%>
<html>
<head>
<style type="text/css">
<!--
.vc_basic {
	font-family: Verdana, Arial, "굴림";
	font-size: 12px;
	color: #333333;
	text-decoration: none;
	line-height: normal;
}
body {
	margin-left: 0px;
	margin-top: 0px;
	color:#333333;
}
.style3 {
	font-size: 22px;
	font-weight: bold;
	height:40px !important;
	padding-top:10px;
}
.style4 {color: #333333}
.style5 {
	color: #00a0d2;
	font-weight: bold;
}
.style7 {color: #666666}
.style8 {color: #00a0d2}
.style12 {font-family: Verdana, Arial, "굴림"; font-size: 11px; color: #333333; text-decoration: none; line-height: normal; }


.brx				{ border-right:none !important; }
.btx				{ border-top:none !important; }
.bbx				{ border-bottom:none !important; }
.bb2				{ border-bottom:2px solid #b2b2b2; }
.table_box 		{	font-family: Verdana, Arial, "굴림";
	font-size: 12px;
	border:2px solid #b2b2b2; border-collapse:collapse;
	width:100%;}
.table_box th {border-top:2px solid #b2b2b2; border-left:2px solid #b2b2b2; border-collapse:collapse;
	text-align:center; height:22px; 	background-color:#f0f0f0}
.table_est {	font-family: Verdana, Arial, "굴림";
	font-size: 12px;
	border-top:0px solid #b2b2b2;
	border-right:0px solid #b2b2b2;
	border-bottom:0px solid #b2b2b2;
	border-collapse:collapse;
	width:100%;}
.table_est th {border:1px solid #b2b2b2; border-collapse:collapse; text-align:center; height:22px;background-color:#f0f0f0 }
.table_est td {border:1px solid #b2b2b2; border-collapse:collapse; text-align:center; height:22px; font-size:11px; 	}


-->
</style>

<script type="text/javascript" src="/js/jquery-1.7.2.min.js"></script>
<script type="text/javascript" src="/js/common2.js"></script>
</head>
<body>
<div class="print" style="text-align:right; padding:5px;">
	<a href="#nohref" onclick="cfPrint()"><img src="/images/icon/btn_print.gif" border="0"/></a>
	<a href="#nohref" onclick="self.close()"><img src="/images/icon/btn_close.gif" border="0"/></a>
</div>

<table width="869" height="1400"  cellspacing="0" cellpadding="0">
<tr>
	<td background="img/bg.jpg" style="background-repeat:no-repeat; background-position:bottom;padding-left:5px;" >
  			<table  height="1400" cellpadding="0" cellspacing="0" class="table_box"  >
				<colgroup>
					<col width="30px"/>
					<col/>
				</colgroup>
				<tbody>
					<tr height="10">
						<th class="bl2"></th>
						<td class="br2 p0">
							<table cellpadding="0" cellspacing="0" class="table_est">
							<colgroup>
								<col width="78px"/>
								<col width="101px"/>
								<col width="60px"/>
								<col width="92px"/>
								<col width="60px"/>
								<col width="100px"/>
								<col width="60px"/>
								<col width="110px"/>
								<col width="60px"/>
								<col/>
							</colgroup>
							<tbody>
								<tr>
									<td colspan="10" class="brx btx"><p class="style3"><%= estList.get("title",0) %></p></td>
								</tr>
								<tr>
									<th class="bt1"><p><b><%= "1".equals(estList.get("est_type",0)) ? "견적" : "예약" %>번호</b></p></th>
									<td class="c"><%= estList.get("est_no",0) %></td>
									<th class="bt1"><p><b>발행일</b></p></th>
									<td class="c"><%= StringUtil.toDate(estList.get("issue_dt",0),".") %></td>
									<th class="bt1"><p><b>작성자</b></p></th>
									<td class="c"><%= estList.get("issue_user",0) %></td>
									<th class="bt1"><p>구분</p></th>
									<td><%= estList.get("est_gubn",0) %></td>
									<th class="bt1"><p>비고</p></th>
									<td class="brx"><%= estList.get("est_remarks",0) %></td>
								</tr>
							</tbody>
							</table>
						</td>
					</tr>

					<tr height="10">
						<th class="bl2" rowspan="2"><p><b>고<br/>객<br/>기<br/>본<br/>정<br/>보</b></p></th>
						<td class="p0 br2">
							<table cellpadding="0" cellspacing="0" class="table_est">
							<colgroup>
								<col width="80px"/>
								<col width="200px"/>
								<col width="30px"/>
								<col width="100px"/>
								<col width="100px"/>
								<col width="100px"/>
								<col/>
							</colgroup>
							<tbody id="customer">
								<tr>
									<th><p>이름</p></th>
									<th><p>영문</p></th>
									<th><p>성별</p></th>
									<th><p>생년월일</p></th>
									<th><p>연락처</p></th>
									<th><p>이메일</p></th>
									<th class="brx"><p>비고</p></th>
								</tr>
							<%	if (customerList.size() == 0) { %>
								<tr>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td class="brx"></td>
								</tr>
							<%	} %>
							<%	for (int i = 0; i < customerList.size(); i++) { %>
								<tr>
									<td>
										<%= customerList.get("customer_name", i) %>
									</td>
									<td><%= StringUtil.nvl(customerList.get("customer_eng_name", i)) %></td>
									<td><%= customerList.get("sex", i) %></td>
									<td><%= StringUtil.nvl(customerList.get("res_no", i)) %></td>
									<td><%= StringUtil.nvl(customerList.get("tel_no", i)) %></td>
									<td><%= StringUtil.nvl(customerList.get("email_addr", i)) %></td>
									<td class="brx"><%= StringUtil.nvl(customerList.get("remarks", i)) %></td>
								</tr>
							<%	} %>
							</tbody>
							</table>
						</td>
					</tr>


					<tr height="10">
						<td class="p0">
							<table cellpadding="0" cellspacing="0" class="table_est">
							<colgroup>
								<col width="80px"/>
								<col width="200px"/>
								<col width="131px"/>
								<col width="100px"/>
								<col/>
							</colgroup>
							<tbody>
								<tr >
									<th class="btx"><p><b>여행종류</b></p></th>
									<td class="btx">
										<%= estList.get("travel_gubn",0) %> <%= estList.get("travel_type",0) %>
									</td>
									<td class="btx"><%= estList.get("travel_desc",0)%></td>
									<th class="btx"><p><b>여행일정</b></p></th>
									<td class="brx btx">
										<%= StringUtil.toDate(estList.get("travel_start_dt",0),".")%>
										~ <%= StringUtil.toDate(estList.get("travel_end_dt",0),".")%>
										<%= estList.get("island",0) %>
									</td>
								</tr>
								<tr>
									<th><p><b>비고</b></p></th>
									<td colspan="4" class="brx"><%= estList.get("remarks",0)%></td>
								</tr>
							</tbody>
							</table>
						</td>
					</tr>

					<tr height="10">
						<th class="bl2 bt2"><p><b>국<br/>제<br/>선</b></p></th>
						<td class="br2 bt2 p0">
							<table cellpadding="0" cellspacing="0" class="table_est">
							<colgroup>
								<col width="80px"/>
								<col width="252px"/>
								<col />
								<col width="60px"/>
								<col width="60px"/>
								<col width="182px"/>
							</colgroup>
							<tbody id="air">
								<tr>
									<th><p>항공사</p></th>
									<th><p>호노룰루도착</p></th>
									<th><p>호노룰루출발</p></th>
									<th><p>1인요금</p></th>
									<th><p>인원수</p></th>
									<th><p>총액</p></th>
								</tr>
							<%	if (airList.size() == 0) { %>
								<tr>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
								</tr>
							<%	} %>
							<%	for (int i = 0; i < airList.size(); i++) {
									air_amount += airList.getInt("amount",i);
							%>
								<tr>
									<td><%= airList.get("air_name",i) %></td>
									<td><%= airList.get("departure_time",i) %></td>
									<td><%= airList.get("arrival_time",i) %></td>
									<td><%= StringUtil.toPrice(airList.get("price",i)) %></td>
									<td><%= airList.get("person_count",i) %></td>
									<td><%= StringUtil.toPrice(airList.get("amount",i)) %></td>

								</tr>
							<%	} %>
							</tbody>
							<tfooter>
								<tr>
									<th class="bt1"><p>비고</p></th>
									<td colspan="6" class="brx c"><%= estList.get("air_remarks",0) %></td>
								</tr>
							</tfooter>
							</table>
						</td>
					</tr>

					<tr height="10">
						<th class="bl2 bt2"><p><b>주<br/>내<br/>선</b></p></th>
						<td class="br2 bt2 p0">
							<table cellpadding="0" cellspacing="0" class="table_est">
							<colgroup>
								<col width="80px"/>
								<col />
						<%	if (isTransfer) { %>
								<col />
						<%	} %>
								<col />
								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
							</colgroup>
							<tbody id="fly">
								<tr>
									<th><p>항공사</p></th>
									<th><p>출발</p></th>
							<%	if (isTransfer) { %>
									<th><p>경유</p></th>
							<%	} %>
									<th><p>귀환</p></th>
									<th><p>1인요금</p></th>
									<th><p>인원수</p></th>
									<th><p>총액</p></th>
									<th><p>예약금</p></th>
									<th><p>잔금</p></th>
								</tr>
							<%	if (flyList.size() == 0) { %>
								<tr>
									<td></td>
									<td></td>
							<%	if (isTransfer) { %>
									<td></td>
							<%	} %>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
								</tr>
							<%	} %>
							<%	for (int i = 0; i < flyList.size(); i++) {
									total_usd 	+= flyList.getDouble("total_usd",i);
									deposit_usd += flyList.getDouble("deposit_usd",i);
									remain_usd	+= flyList.getDouble("remain_usd",i);
							%>
								<tr>
									<td><%= flyList.get("air_name",i) %></td>
									<td><%= flyList.get("departure_time",i) %></td>
							<%	if (isTransfer) { %>
									<td><%= flyList.get("transfer_time",i) %></td>
							<%	} %>
									<td><%= flyList.get("arrival_time",i) %></td>
									<td><%= flyList.get("price_usd",i) %></td>
									<td><%= flyList.get("person_count",i) %></td>
									<td><%= flyList.get("total_usd",i) %></td>
									<td><%= flyList.get("deposit_usd",i) %></td>
									<td><%= flyList.get("remain_usd",i) %></td>
								</tr>
							<%	} %>
							</tbody>
							<tfooter>
								<tr>
									<th class="bt1"><p>비고</p></th>
									<td colspan="<%= isTransfer ? 9 : 8 %>" class="brx c"><%= estList.get("fly_remarks",0) %></td>
								</tr>
							</tfooter>
							</table>
						</td>
					</tr>

					<tr height="10">
						<th class="bl2 bt2"><p><b>호<br/>텔</b></p></th>
						<td class="br2 bt2 p0">
							<table cellpadding="0" cellspacing="0" class="table_est">
							<colgroup>
								<col width="45px"/>
								<col width="50px"/>
								<col width="50px"/>
								<col />
								<col width="42px"/>
								<col width="42px"/>
								<col width="42px"/>
								<col width="46px"/>
								<col width="46px"/>

								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
							</colgroup>
							<tbody id="hotel">
								<tr>

									<th><p>장소</p></th>
									<th colspan="2"><p>날짜</p></th>
									<th><p>호텔</p></th>
									<th><p>객실</p></th>
									<th><p>침대</p></th>
									<th><p>조식</p></th>
									<th><p>리조트</p></th>
									<th><p>Port</p></th>
									<th><p>1박요금</p></th>
									<th><p>숙박일</p></th>
									<th><p>총액</p></th>
									<th><p>예약금</p></th>
									<th><p>잔금</p></th>
								</tr>
							<%	if (hotelList.size() == 0) { %>
								<tr>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
								</tr>
							<%	} %>
							<%	for (int i = 0; i < hotelList.size(); i++) {
								total_usd 	+= hotelList.getDouble("total_usd",i);
								deposit_usd += hotelList.getDouble("deposit_usd",i);
								remain_usd	+= hotelList.getDouble("remain_usd",i);
							%>
								<tr>
									<td>
										<%= hotelList.get("land_name", i) %>
									</td>
									<td><%=hotelList.get("start_dt", i)%></td>
									<td><%=hotelList.get("end_dt", i)%></td>
									<td>
										<%= hotelList.get("hotel_eng_name", i) %>
									<% 	if (hotelList.getInt("add_person_count",i) > 0) { %>
									 		(추가<%=hotelList.get("add_person_count", i) %>인)
									<%	} %>
									</td>
									<td><%=hotelList.get("room_type", i)%></td>
									<td><%=hotelList.get("bed_type", i)%></td>
									<td><%= hotelList.get("bfst_name", i) %></td>
									<td><%= hotelList.get("resort_name", i) %></td>
									<td><%=hotelList.get("porterage_usd", i)%></td>
									<td><%=hotelList.get("price_usd", i)%></td>
									<td><%=hotelList.get("stay_day", i)%></td>
									<td><%=hotelList.get("total_usd", i)%></td>
									<td><%=hotelList.get("deposit_usd", i)%></td>
									<td><%=hotelList.get("remain_usd", i)%></td>
								</tr>
							<%	} %>
							</tbody>
							<tfooter>
								<tr>
									<th class="bt1"><p>비고</p></th>
									<td colspan="15" class="brx c"><%= estList.get("hotel_remarks",0) %></td>
								</tr>
							</tfooter>
							</table>
						</td>
					</tr>

					<tr height="10">
						<th class="bl2 bt2"><p><b>선<br/>택<br/>관<br/>광</b></p></th>
						<td class="br2 bt2 p0">
							<table cellpadding="0" cellspacing="0" class="table_est">
							<colgroup>
								<col width="45px"/>
								<col width="100px"/>
								<col width="231px"/>
								<col/>
								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
							</colgroup>
							<tbody id="enjoy">
								<tr>
									<th><p>장소</p></th>
									<th><p>날짜</p></th>
									<th><p>상품</p></th>
									<th><p>조건</p></th>
									<th><p>인원수</p></th>
									<th><p>1인요금</p></th>
									<th><p>총액</p></th>
									<th><p>예약금</p></th>
									<th><p>잔금</p></th>
								</tr>
							<%	if (enjoyList.size() == 0) { %>
								<tr>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
								</tr>
							<%	} %>
							<%	for (int i = 0; i < enjoyList.size(); i++) {
									total_usd 	+= enjoyList.getDouble("total_usd",i);
									deposit_usd += enjoyList.getDouble("deposit_usd",i);
									remain_usd	+= enjoyList.getDouble("remain_usd",i);
							%>
								<tr>
									<td><%= enjoyList.get("land_name", i) %></td>
									<td><%=enjoyList.get("start_dt", i)%></td>
									<td><%= enjoyList.get("enjoy_name", i) %></td>
									<td><%=enjoyList.get("enjoy_cond", i)%></td>
									<td><%=enjoyList.get("person_count", i)%></td>
									<td><%=enjoyList.get("price_usd", i)%></td>
									<td><%=enjoyList.get("total_usd", i)%></td>
									<td><%=enjoyList.get("deposit_usd", i)%></td>
									<td><%=enjoyList.get("remain_usd", i)%></td>
								</tr>
							<%	} %>
							</tbody>
							<tfooter>
								<tr>
									<th class="bt1"><p>비고</p></th>
									<td colspan="9" class="brx c"><%= estList.get("enjoy_remarks",0) %></td>
								</tr>
							</tfooter>
							</table>
						</td>
					</tr>

					<tr height="10">
						<th class="bl2 bt2"><p><b>렌<br/>터<br/>카</b></p></th>
						<td class="br2 bt2 p0">
							<table cellpadding="0" cellspacing="0" class="table_est">
							<colgroup>
								<col width="45px"/>
								<col width="50px"/>
								<col width="50px"/>
								<col/>
								<col width="40px"/>
								<col width="75px"/>

								<col width="60px"/>
								<col width="50px"/>
								<col width="89px"/>
								<col width="30px"/>
								<col width="29px"/>

								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
							</colgroup>
							<tbody id="car">
								<tr>
									<th><p>장소</p></th>
									<th colspan="2"><p>날짜</p></th>
									<th><p>조건</p></th>
									<th><p>픽업</p></th>
									<th><p>차종</p></th>

									<th><p>운전자</p></th>
									<th><p>GPS</p></th>
									<th><p>픽업/반납</p></th>
									<th><p>일수</p></th>
									<th><p>대수</p></th>

									<th><p>1일요금</p></th>
									<th><p>총액</p></th>
									<th><p>예약금</p></th>
									<th><p>잔금</p></th>
								</tr>
							<%	if (carList.size() == 0) { %>
								<tr>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
								</tr>
							<%	} %>
							<%	for (int i = 0; i < carList.size(); i++) {
									total_usd 	+= carList.getDouble("total_usd",i);
									deposit_usd += carList.getDouble("deposit_usd",i);
									remain_usd	+= carList.getDouble("remain_usd",i);
							%>
								<tr>
									<td><%= carList.get("land_name", i) %></td>
									<td><%=carList.get("start_dt", i)%></td>
									<td><%=carList.get("end_dt", i)%></td>
									<td><%=carList.get("rent_desc", i)%></td>
									<td><%=carList.get("pickup_name", i)%></td>
									<td><%= carList.get("car_type_name", i) %></td>

									<td><%=carList.get("driver_name", i)%></td>
									<td><%= carList.get("gps_name", i) %></td>
									<td><%= carList.get("return_name", i) %></td>
									<td><%=carList.get("rent_day", i)%></td>
									<td><%=carList.get("car_count", i)%></td>

									<td><%=carList.get("price_usd", i)%></td>
									<td><%=carList.get("total_usd", i)%></td>
									<td><%=carList.get("deposit_usd", i)%></td>
									<td><%=carList.get("remain_usd", i)%></td>
								</tr>
							<%	} %>
							</tbody>
							<tfooter>
								<tr>
									<th class="bt1"><p>비고</p></th>
									<td colspan="15" class="brx c"><%= estList.get("car_remarks",0) %></td>
								</tr>
							</tfooter>
							</table>
						</td>
					</tr>

					<tr height="10">
						<th class="bl2 bt2"><p><b>보<br/>험</b></p></th>
						<td class="br2 bt2 p0">
							<table cellpadding="0" cellspacing="0" class="table_est">
							<colgroup>
								<col width="45px"/>
								<col/>
								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
								<col width="60px"/>
							</colgroup>
							<tbody id="insure">
								<tr>
									<th><p>항목</p></th>
									<th><p>내용</p></th>
									<th><p>인원수</p></th>
									<th><p>1인요금</p></th>
									<th><p>총액</p></th>
									<th><p>예약금</p></th>
									<th><p>잔금</p></th>
								</tr>
							<%	if (insureList.size() == 0) { %>
								<tr>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
								</tr>
							<%	} %>
							<%	for (int i = 0; i < insureList.size(); i++) {
									total_usd 	+= insureList.getDouble("total_usd",i);
									deposit_usd += insureList.getDouble("deposit_usd",i);
									remain_usd	+= insureList.getDouble("remain_usd",i);
							%>
								<tr>
									<td>
										<%=insureList.get("insure_name", i)%>
									</td>
									<td><%=insureList.get("insure_info", i)%></td>
									<td><%=StringUtil.nvl(insureList.get("person_count", i))%></td>
									<td><%=StringUtil.nvl(insureList.get("price_usd", i))%></td>
									<td><%=StringUtil.nvl(insureList.get("total_usd", i))%></td>
									<td><%=StringUtil.nvl(insureList.get("deposit_usd", i))%></td>
									<td><%=StringUtil.nvl(insureList.get("remain_usd", i))%></td>
								</tr>
							<%	} %>
							</tbody>
							<tfooter>
								<tr>
									<th class="bt1"><p>비고</p></th>
									<td colspan="7" class="brx c"><%= estList.get("insure_remarks",0) %></td>
								</tr>
							</tfooter>
							</table>
						</td>
					</tr>


					<tr height="10">
						<th class="bb2"><p><b>결<br/>재<br/>사<br/>항</p></th>
						<td class="bb2">
							<table cellpadding="0" cellspacing="0" class="table_est">
							<colgroup>
								<col width="270px"/>
								<col width="270px"/>
								<col width="95px"/>
								<col width="70px"/>
								<col width="70px"/>
								<col width="70px"/>
							</colgroup>
							<tbody id="enjoy">
								<tr>
									<th><p>총내역</p></th>
									<th><p>예약금내역</p></th>
									<th><p></p></th>
									<th><p>총액</p></th>
									<th><p>예약금</p></th>
									<th class="brx"><p>잔금</p></th>
								</tr>
								<tr>
									<td rowspan="4" class="bbx"><%= StringUtil.toHTML(estList.get("total_desc",0)) %></td>
									<td rowspan="4" class="bbx"><%= StringUtil.toHTML(estList.get("deposit_desc",0)) %></td>
									<th><p>국제선(&#8361;)</p></th>
									<td><%= StringUtil.toPrice(air_amount) %></td>
									<td></td>
									<td class="brx"></td>
								</tr>
								<tr>
									<th><p>미화($)</p></th>
									<td><%= total_usd %></td>
									<td><%= deposit_usd %></td>
									<td class="brx"><%= remain_usd %></td>
								</tr>
								<tr>
									<th><p>원화(&#8361;)</p></th>
									<td><%= StringUtil.toPrice((long)(air_amount + deposit_usd * deposit_currency + remain_usd * remain_currency)) %></td>
									<td><%= StringUtil.toPrice((long)(deposit_usd * deposit_currency)) %></td>
									<td class="brx"><%= StringUtil.toPrice((long)(remain_usd * remain_currency)) %></td>
								</tr>
								<tr>
									<th class="bbx" colspan="2"><p>환율</p></th>
									<td class="bbx"><%= StringUtil.toPrice(estList.get("deposit_currency",0)) %></td>
									<td class="brx bbx"><%= StringUtil.toPrice(estList.get("remain_currency",0)) %></td>
								</tr>
							</tbody>
							</table>
						</td>
					</tr>
      <tr>
        <td colspan="2" style="padding:5px;" class="vc_basic" valign="top"><p><span class="style5"><br>※유의사항(필독)※</span><br>
          <br>
              <span class="style7">1.</span> <strong>조인하와이</strong> <span class="style7">하와이 사무실 위치안내(OPEN AM 8:00 ~ PM 5:00)<br>
            * 175 Paoakalani Ave, Honolulu, Hawaii 96815<br>
            &nbsp;&nbsp;&nbsp;Hyatt Place Hotel Lobby(현지명 : JOINHAWAIIUSA)<br>
            * 현지 사무소 연락처 T. 1-080-772-2691 F. 808-445-9081 영업시간. AM08:00~PM05:00<br>
            * 한국 연락사무소 연락처 T. 02-402-1040 / 02-392-1044   F. 0303-0950-1044 영업시간. AM09:00~PM06:00<br>
            <br>
            2. 결제안내<br>
            하와이 현지에서 잔금 결제는 조인하와이 담당자에게만 결제하셔야 합니다.<br>
            한국에서 결제시 예약금과 잔금은 지불시점의 매입환율이 적용됩니다.(카드결제는 별도 문의바랍니다.)<br>
            한국지사: 신한은행 110-341-818 061 예금주 :조인하와이 김홍석<br>
            신한은행 180-005-677248 예금주: JOIN HAWAII KIM HONG SUK(외화예금계좌)<br>
            <br>
            3. 예약및 확인<br>
            예약확인서상의 </span><span class="style8">예약사항을 꼭 확인하셔야 하며, 미이행 시 발생되는 불이익은 책임지지 않습니다.</span><br>
            <span class="style7">조인하와이의 모든 상품은 자유여행을 기본으로 진행되며, 전일정 가이드가 안내하는 패키지투어가 아닙니다.<br>
            선택관광과 렌터카는 출발 20일전까지 예약이 가능하며, 현지 사정 또는 고객의 편의를 위해 변경될 수 있습니다.</span><br>
            <span class="style8">EX) 객실타입, 식사유무, 선택관광, 렌터카등 예약확인서상에 표시되지 않은 사항은 책임지지 않습니다.<br>
            * 타사에서 예약하신 옵션에 의한 (불만,사고,보험처리등)의 문제 발생시 조인하와이에서는 일체 책임지지 않습니다.</span><br>
            <span class="style7">* 하와이의 모든 호텔은 룸 BED TYPE과 층수는 확정 예약이 불가 합니다.<br>
            * 하와이의 모든 호텔은 오후3시 체크인이며, 입실 시 해외사용 신용카드로 데파짓을 하셔야 합니다.<br>
            <br>
            4. 취소및 변경<br>
            호텔예약 취소나 변경은 각 호텔마다 상이함으로 홈페이지상의 호텔정보를 참고하시거나 담당자에게 문의바랍니다.<br>
            주내선항공과 렌터카는 취소나 변경 시 일정 위약금이 있습니다.<br>
          선택관광은 출발 7일전까지 취소(위약금100%)나 변경 가능합니다. (일부 선택관광 제외)<br>
          </span></td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>

